package com.example.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.controller.vo.EvaluationsVo;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * <p>
 * 评论表 Mapper 接口
 * </p>
 *
 * @author yzy
 * @since 2025-08-04
 */
public interface EvaluationsVoMapper extends BaseMapper<EvaluationsVo> {

//    @Select("SELECT\n" +
//            "evaluations.*,\n" +
//            "`user`.user_name,\n" +
//            "`user`.user_avatar\n" +
//            "FROM\n" +
//            "evaluations\n" +
//            "LEFT JOIN\n" +
//            "user\n" +
//            "ON\n" +
//            "evaluations.commenter_id = user.id\n" +
//            "WHERE\n" +
//            "product_id = #{productId}")
    List<EvaluationsVo> selectlist(@Param("productId") Integer productId);


}
